Tabela Period

Definicja tabeli Period

Name

Period

Code

Period

Comment

okres kosztowy


Lista kolumn tabeli Period

Name

Code

PeriodID

PeriodID

PeriodStatusID

PeriodStatusID

PeriodTypeID

PeriodTypeID

StartDT

StartDT

StopDT

StopDT

ShowInReport

ShowInReport

Description

Description


Kolumna PeriodID tabeli Period

Definicja kolumny PeriodID tabeli Period

Name

PeriodID

Code

PeriodID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PeriodStatusID tabeli Period

Definicja kolumny PeriodStatusID tabeli Period

Name

PeriodStatusID

Code

PeriodStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PeriodTypeID tabeli Period

Definicja kolumny PeriodTypeID tabeli Period

Name

PeriodTypeID

Code

PeriodTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli Period

Definicja kolumny StartDT tabeli Period

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Period

Definicja kolumny StopDT tabeli Period

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna ShowInReport tabeli Period

Definicja kolumny ShowInReport tabeli Period

Name

ShowInReport

Code

ShowInReport

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Description tabeli Period

Definicja kolumny Description tabeli Period

Name

Description

Code

Description

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Lista kluczy tabeli Period

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Period

Definicja klucza Identifier_1 tabeli Period

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment